| Power Automate – How to export attachments from SharePoint List Item. | 您所在的位置：网站首页 › Solved Need to export all attachments from a single Proje › Power Automate – How to export attachments from SharePoint List Item. |
Power Automate – How to export attachments from SharePoint List Item.
|
Introduction Hi Friends, in this post let us examine how we can use Power Automate to export attachments from the SharePoint List item. To explain the usage of this scenario, let us extend this Cloud Flow to send the attachments in Email. Perhaps you can use the same concept of exporting the attachments and do the following Send the attachment over an email (will see in this post)Store all the attachments in a document library.Store all the attachments in a Onedrive folder.Note The flow which I am gonna show you will use manual trigger but the same can be used with automatic triggers like When an item is added or modified etc. Focus on the Flow Consider a sample list with only the Title field and the attachments for the list has to be enabled. Add an item with a single or multiple attachments. Let us start designing the flow Create an Instant cloud flow, give a unique name and select the trigger Manual trigger a flow
Add an action named Initialize Variable as an array to store all the attachments from a list item.
Add an action named Get attachments and fill in the following propertiesSite Address – SharePoint site where the list existsList Name – Name of the listId – List item ID to export the attachment(s)
Add an action named Apply to each to traverse through the attachments and store the result in an array that is initialized in the above action.Inside the Apply to each action add actions one below the otherGet attachment content – The above action Get attachments will not return the contents, but it returns the File Identifier and other metadata information. Using File Identifier we can get the attachment content.Append to array variable – Append the Attachment name and Attachment content in the below format as a JSON array. The format mentioned below should be as it is without changing the key names. The same format is expected in the email action which we will add below the Apply to each action.
{
"Name": ,
"ContentBytes":
}
Add an action named Send an email (v2) to send the exported attachments to any user. Fill in the following properties. You have to collapse the advanced option for the attachments property.To – To email of the userSubject – Email subjectBody – Some email contentAttachments – Change it to dynamic values and pass the array variable as shown below
See how easy it is. Are you expecting anything? we are done with the flow. Execute the flow and enjoy the outcome. 
Happy Flowing…. Rate this:Share the knowledgeClick to share on Twitter (Opens in new window)Click to share on Facebook (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Reddit (Opens in new window)Click to share on Tumblr (Opens in new window)Click to share on Pinterest (Opens in new window)Click to share on Pocket (Opens in new window)Click to share on Telegram (Opens in new window)Click to share on WhatsApp (Opens in new window)Click to email a link to a friend (Opens in new window)Like Loading... Related |
【本文地址】